#-------------------------------------------------------------------------------
# Name:        sqlite3
# Purpose:
#
# Author:      fanfq
#
# Created:     08/05/2012
# Copyright:   (c) fanfq 2012
# Licence:     <your licence>
#-------------------------------------------------------------------------------

import sqlite3

#select
conn = sqlite3.connect("c:/db_name.db")
cur = conn.cursor()
sql = "select * from tab_name group by column_name"
cur.execute(sql)
for row in cur:
    print(row[2],row[6],row[7],row[8])
cur.close()
conn.close()    
